package com.atguigu.realtime.bean;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

import java.math.BigDecimal;

@Data
@NoArgsConstructor
@AllArgsConstructor
public class ProvinceStats {
    //统计开始时间 yyyy-MM-dd HH:mm:ss
    private String stt;
    //统计结束时间
    private String edt;
    private Long province_id;
    private String province_name;
    private String area_code;
    private String iso_code;
    private String iso_3166_2;
    private BigDecimal order_amount;
    private Long order_count;
    private Long ts;
}

/*

 " tumble_start(et, interval '5' second) stt, " +
                                        " tumble_end(et, interval '5' second) edt, " +
                                        " province_id, " +
                                        " province_name, " +
                                        " province_area_code area_code, " +
                                        " province_iso_code iso_code, " +
                                        " province_3166_2_code iso_3166_2," +
                                        " sum(split_total_amount) order_amount, " +
                                        " count(distinct(order_id)) order_count," +
                                        " unix_timestamp()*1000 as ts " +
 */